1 define mw_prefix
='{$wgDBprefix}';
3 ALTER TABLE &mw_prefix.archive
MODIFY ar_user
DEFAULT 0 NOT NULL;
4 ALTER TABLE &mw_prefix.archive
MODIFY ar_deleted
CHAR(1);
5 CREATE INDEX &mw_prefix.archive_i03
ON &mw_prefix.
archive (ar_rev_id
);
7 ALTER TABLE &mw_prefix.page
MODIFY page_is_redirect
default '0';
8 ALTER TABLE &mw_prefix.page
MODIFY page_is_new
default '0';
9 ALTER TABLE &mw_prefix.page
MODIFY page_latest
default 0;
10 ALTER TABLE &mw_prefix.page
MODIFY page_len
default 0;
12 ALTER TABLE &mw_prefix.categorylinks
MODIFY cl_sortkey
VARCHAR2(230);
13 ALTER TABLE &mw_prefix.categorylinks
ADD cl_sortkey_prefix
VARCHAR2(255) DEFAULT '' NOT NULL;
14 ALTER TABLE &mw_prefix.categorylinks
ADD cl_collation
VARCHAR2(32) DEFAULT '' NOT NULL;
15 ALTER TABLE &mw_prefix.categorylinks
ADD cl_type
VARCHAR2(6) DEFAULT 'page' NOT NULL;
16 DROP INDEX &mw_prefix.categorylinks_i01
;
17 CREATE INDEX &mw_prefix.categorylinks_i01
ON &mw_prefix.
categorylinks (cl_to
,cl_type
,cl_sortkey
,cl_from
);
18 CREATE INDEX &mw_prefix.categorylinks_i03
ON &mw_prefix.
categorylinks (cl_collation
);
20 ALTER TABLE &mw_prefix.filearchive
MODIFY fa_deleted_user
DEFAULT 0 NOT NULL;
21 ALTER TABLE &mw_prefix.filearchive
MODIFY fa_size
DEFAULT 0;
22 ALTER TABLE &mw_prefix.filearchive
MODIFY fa_width
DEFAULT 0;
23 ALTER TABLE &mw_prefix.filearchive
MODIFY fa_height
DEFAULT 0;
24 ALTER TABLE &mw_prefix.filearchive
MODIFY fa_bits
DEFAULT 0 NOT NULL;
25 ALTER TABLE &mw_prefix.filearchive
MODIFY fa_user
DEFAULT 0 NOT NULL;
26 ALTER TABLE &mw_prefix.filearchive
MODIFY fa_deleted
DEFAULT 0;
28 ALTER TABLE &mw_prefix.image
MODIFY img_size
DEFAULT 0;
29 ALTER TABLE &mw_prefix.image
MODIFY img_width
DEFAULT 0;
30 ALTER TABLE &mw_prefix.image
MODIFY img_height
DEFAULT 0;
31 ALTER TABLE &mw_prefix.image
MODIFY img_bits
DEFAULT 0 NOT NULL;
32 ALTER TABLE &mw_prefix.image
MODIFY img_user
DEFAULT 0 NOT NULL;
34 ALTER TABLE &mw_prefix.interwiki
ADD iw_api
BLOB DEFAULT EMPTY_BLOB();
35 ALTER TABLE &mw_prefix.interwiki
MODIFY iw_api
DEFAULT NULL NOT NULL;
36 ALTER TABLE &mw_prefix.interwiki
ADD iw_wikiid
VARCHAR2(64);
38 ALTER TABLE &mw_prefix.ipblocks
MODIFY ipb_user
DEFAULT 0 NOT NULL;
39 ALTER TABLE &mw_prefix.ipblocks
MODIFY ipb_by
DEFAULT 0;
41 CREATE TABLE &mw_prefix.
iwlinks (
42 iwl_from
NUMBER DEFAULT 0 NOT NULL,
43 iwl_prefix
VARCHAR2(20) DEFAULT '' NOT NULL,
44 iwl_title
VARCHAR2(255) DEFAULT '' NOT NULL
46 CREATE UNIQUE INDEX &mw_prefix.iwlinks_ui01
ON &mw_prefix.
iwlinks (iwl_from
, iwl_prefix
, iwl_title
);
47 CREATE UNIQUE INDEX &mw_prefix.iwlinks_ui02
ON &mw_prefix.
iwlinks (iwl_prefix
, iwl_title
, iwl_from
);
49 ALTER TABLE &mw_prefix.logging
MODIFY log_user
DEFAULT 0 NOT NULL;
50 ALTER TABLE &mw_prefix.logging
MODIFY log_deleted
CHAR(1);
52 CREATE TABLE &mw_prefix.
module_deps (
53 md_module
VARCHAR2(255) NOT NULL,
54 md_skin
VARCHAR2(32) NOT NULL,
57 CREATE UNIQUE INDEX &mw_prefix.module_deps_u01
ON &mw_prefix.
module_deps (md_module
, md_skin
);
59 CREATE TABLE &mw_prefix.
msg_resource_links (
60 mrl_resource
VARCHAR2(255) NOT NULL,
61 mrl_message
VARCHAR2(255) NOT NULL
63 CREATE UNIQUE INDEX &mw_prefix.msg_resource_links_u01
ON &mw_prefix.
msg_resource_links (mrl_message
, mrl_resource
);
65 CREATE TABLE &mw_prefix.
msg_resource (
66 mr_resource
VARCHAR2(255) NOT NULL,
67 mr_lang
varchar2(32) NOT NULL,
68 mr_blob
BLOB NOT NULL,
69 mr_timestamp
TIMESTAMP(6) WITH TIME ZONE NOT NULL
71 CREATE UNIQUE INDEX &mw_prefix.msg_resource_u01
ON &mw_prefix.
msg_resource (mr_resource
, mr_lang
);
73 ALTER TABLE &mw_prefix.oldimage
MODIFY oi_name
DEFAULT 0;
74 ALTER TABLE &mw_prefix.oldimage
MODIFY oi_size
DEFAULT 0;
75 ALTER TABLE &mw_prefix.oldimage
MODIFY oi_width
DEFAULT 0;
76 ALTER TABLE &mw_prefix.oldimage
MODIFY oi_height
DEFAULT 0;
77 ALTER TABLE &mw_prefix.oldimage
MODIFY oi_bits
DEFAULT 0;
78 ALTER TABLE &mw_prefix.oldimage
MODIFY oi_user
DEFAULT 0 NOT NULL;
80 ALTER TABLE &mw_prefix.querycache
MODIFY qc_value
DEFAULT 0;
82 ALTER TABLE &mw_prefix.recentchanges
MODIFY rc_user
DEFAULT 0 NOT NULL;
83 ALTER TABLE &mw_prefix.recentchanges
MODIFY rc_cur_id
DEFAULT 0 NOT NULL;
84 ALTER TABLE &mw_prefix.recentchanges
MODIFY rc_this_oldid
DEFAULT 0;
85 ALTER TABLE &mw_prefix.recentchanges
MODIFY rc_last_oldid
DEFAULT 0;
86 ALTER TABLE &mw_prefix.recentchanges
MODIFY rc_moved_to_ns
DEFAULT 0 NOT NULL;
87 ALTER TABLE &mw_prefix.recentchanges
MODIFY rc_deleted
CHAR(1);
88 ALTER TABLE &mw_prefix.recentchanges
MODIFY rc_logid
DEFAULT 0;
90 ALTER TABLE &mw_prefix.revision
MODIFY rev_page
NOT NULL;
91 ALTER TABLE &mw_prefix.revision
MODIFY rev_user
DEFAULT 0;
93 ALTER TABLE &mw_prefix.updatelog
ADD ul_value
BLOB;
95 ALTER TABLE &mw_prefix.user_groups
MODIFY ug_user
DEFAULT 0 NOT NULL;
97 ALTER TABLE &mw_prefix.user_newtalk
MODIFY user_id
DEFAULT 0;